Health Data Information & Management System (HDIMS)

Abstract

The Health Data Information & Management System (HDIMS) is a comprehensive web-based healthcare management platform designed to digitize and integrate all critical healthcare workflows under a unified system. Many small to medium-sized healthcare facilities continue to rely on paper-based records, disconnected spreadsheets, and siloed information systems, leading to delays in diagnosis, prescription errors, duplication of tests, and poor patient experiences. HDIMS addresses these challenges by providing a centralized digital platform built on ASP.NET Web Forms with a C# backend and Microsoft SQL Server database. The system integrates appointment management, clinical prescription and diagnosis documentation, laboratory test management, pharmacy billing, and telemedicine consultations through five role-specific modules: Administrator, Doctor, Patient, Medical Staff (Pharmacy), and Lab Staff. Key features include real-time slot-based appointment booking, a structured prescription writing module with a temporary staging buffer, color-coded medication timing display, digital lab report upload and status tracking, automated pharmacy bill generation from prescription data, and Jitsi Meet-based video consultation with real-time chat. All 30 functional test cases and 5 integration test scenarios passed successfully, with 100% task completion in user acceptance testing. The system demonstrates how modern web technologies can be applied to build a secure, scalable, and efficient healthcare information management solution suitable for small to mid-size clinics and hospitals.

Introduction

The text describes the design and implementation of HDIMS (Health Data Information and Management System), a unified web-based healthcare platform aimed at solving inefficiencies in fragmented, paper-based medical record systems in small and medium healthcare facilities.

Healthcare organizations often suffer from disconnected systems for patient records, appointments, prescriptions, lab tests, and billing, leading to errors, delays, and poor coordination. HDIMS addresses these issues by integrating all major healthcare workflows into a single system with role-based access for doctors, patients, administrators, pharmacy staff, and lab staff.

The system is built using a three-tier architecture (ASP.NET, C#, SQL Server) and supports key features such as online appointment scheduling, digital prescriptions, lab test management, pharmacy billing, telemedicine via Jitsi Meet, real-time chat, and secure payments. It also emphasizes security, scalability, usability, and data integrity, with role-based access control and structured database design.

Existing research supports the system’s components, showing that electronic medical records reduce errors, telemedicine is effective, and digital scheduling improves efficiency. However, HDIMS goes further by integrating all these functions into a single cohesive platform.

The methodology follows an iterative waterfall model, with modular development and testing. The system uses a well-structured database (18 tables in 3NF) to manage doctors, patients, prescriptions, lab orders, billing, and video sessions.

Conclusion

The Health Data Information and Management System has been successfully designed, implemented, and tested as a comprehensive web-based healthcare management platform. The system integrates five role-specific modules — Doctor, Patient, Medical Staff (Pharmacy), Lab Staff, and Administrator — into a unified platform supported by a centralized SQL Server database. Key engineering decisions — the temporary prescription staging mechanism, slot-level appointment availability filtering, Doctor Ordered Tests status tracking, and Jitsi Meet video integration — contribute to a system that closely models the operational requirements of a real healthcare facility. All 30 functional test cases and 5 integration test scenarios passed. User acceptance testing across all five roles yielded a 100% task completion rate with no critical usability issues. The project demonstrates how ASP.NET Web Forms and C# can be applied to build a multi-role enterprise healthcare application with structured data workflows, reinforcing key software engineering principles: modular design for managing complexity, structured data entry for clinical error reduction, and iterative testing for validating inter-module dependencies.

References

[1] D. W. Bates et al., \"Effect of Computerized Physician Order Entry and a Team Intervention on Prevention of Serious Medication Errors,\" JAMA, vol. 280, no. 15, pp. 1311–1316, Oct. 1998. [2] K. Hayrinen, K. Saranto, and P. Nykanen, \"Definition, structure, content, use and impacts of electronic health records: A review,\" Int. J. Med. Inform., vol. 77, no. 5, pp. 291–304, May 2008. [3] J. Adler-Milstein et al., \"More Than Half Of US Hospitals Have At Least A Basic EHR,\" Health Affairs, vol. 33, no. 9, pp. 1664–1671, Sep. 2014. [4] A. Sunyaev and S. Schneider, \"Cloud Services Certification,\" Commun. ACM, vol. 56, no. 2, pp. 33–36, 2013. [5] I. Dey, A. Sinha, and P. Bandyopadhyay, \"A Comprehensive Framework for Healthcare IS Design using Multi-Tier Web Architecture,\" in Proc. IEEE ICACCCT, 2014, pp. 1192–1197. [6] M. M. Islam and A. K. Nag, \"Web-based Hospital Management System Using ASP.NET,\" IJCSIT, vol. 5, no. 2, pp. 1229–1232, 2014. [7] D. Gupta and B. Denton, \"Appointment scheduling in health care: Challenges and opportunities,\" IIE Trans., vol. 40, no. 9, pp. 800–819, 2008. [8] T. Cayirli and E. Veral, \"Outpatient scheduling in health care: A review,\" Prod. Oper. Manag., vol. 12, no. 4, pp. 519–549, 2003. [9] M. Murray and C. Tantau, \"Same-day appointments,\" Fam. Pract. Manag., vol. 7, no. 8, pp. 45–50, 2000. [10] A. G. Ekeland, A. Bowes, and S. Flottorp, \"Effectiveness of telemedicine: A systematic review,\" Int. J. Med. Inform., vol. 79, no. 11, pp. 736–771, Nov. 2010. [11] R. Bashshur et al., \"The taxonomy of telemedicine,\" Telemed. e-Health, vol. 17, no. 6, pp. 484–494, Jul.2011. [12] N. M. Hjelm, \"Benefits and drawbacks of telemedicine,\" J. Telemed. Telecare, vol. 11, no. 2,pp. 60–70, 2005. [13] G. S. Birkhead, M. Klompas, and N. R. Shah, \"Uses of electronic health records for public health surveillance,\" Annu. Rev. Public Health, vol. 36, pp. 345–359, 2015. [14] E. Ammenwerth et al., \"The Effect of Electronic Prescribing on Medication Errors,\" JAMIA, vol. 15, no. 5, pp. 585–600, Sep. 2008. [15] A. Agrawal, \"Medication errors: Prevention using information technology systems,\" Br. J. Clin. Pharmacol., vol. 67, no. 6, pp. 681–686, Jun. 2009. [16] B. A. Friedman, \"The future of laboratory information systems,\" Clin. Lab. Med., vol. 11, no. 1,pp. 237–249, Mar. 1991. [17] L. Pantanowitz et al., \"Review of the current state of whole slide imaging in pathology,\" J. Pathol. Inform., vol. 2, p. 36, Sep. 2011. [18] A. Georgiou et al., \"The impact of computerised physician order entry systems on pathology services,\" Int. J. Med. Inform., vol. 76, no. 7, pp. 514–529, Jul. 2007. [19] C. A. Pedersen, P. J. Schneider, and D. J. Scheckelhoff, \"ASHP national survey of pharmacy practice,\" Am. J. Health-Syst. Pharm., vol. 69, no. 9, pp. 768–785, May 2012. [20] L. T. Kohn, J. M. Corrigan, and M. S. Donaldson, To Err is Human: Building a Safer Health System. Washington, DC: National Academy Press, 2000. [21] P. P. Chen and M. Hadzikadic, \"A Normalized Relational Database Schema for Clinical Data Management,\" in Proc. IEEE CBMS, 1995, pp. 47–52. [22] C. J. McDonald, \"The barriers to electronic medical record systems and how to overcome them,\" JAMIA, vol. 4, no. 3, pp. 213–221, 1997. [23] A. Appari and M. E. Johnson, \"Information security and privacy in healthcare,\" Int. J. Internet Enterprise Manag., vol. 6, no. 4, pp. 279–314, 2010. [24] C. S. Kruse et al., \"Cybersecurity in healthcare: A systematic review,\" Technol. Health Care, vol. 25, no. 1, pp. 1–10, 2017.

Copyright

Copyright © 2026 Prof. Rajeshri Umesh Vaidya, Mr. Ayush Shrikrishna Mhatarmare, Mr. Pratham Sachin Majethia, Mr. Ajinkya Pramod Kedar, Mr. Piyush Satish Mokalkar, Mr. Sumit Vitthalrao Pranjale. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.